CREATE TABLE [dbo].[UniformTag]
(
[UniformKey] [uniqueidentifier] NOT NULL,
[TagKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[IsPrimary] [bit] NOT NULL CONSTRAINT [DF_UniformTag_IsPrimary] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[UniformTag] ADD CONSTRAINT [PK_UniformTag] PRIMARY KEY CLUSTERED ([UniformKey], [TagKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UniformTag_CreatedByUserKey] ON [dbo].[UniformTag] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_UniformTag_TagKey] ON [dbo].[UniformTag] ([TagKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UniformTag] ADD CONSTRAINT [FK_UniformTag_Tag] FOREIGN KEY ([TagKey]) REFERENCES [dbo].[Tag] ([TagKey])
GO
ALTER TABLE [dbo].[UniformTag] ADD CONSTRAINT [FK_UniformTag_UniformRegistry] FOREIGN KEY ([UniformKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO
ALTER TABLE [dbo].[UniformTag] ADD CONSTRAINT [FK_UniformTag_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO